package com.ygqh.baby.po;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class WdtQybOrderDetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WdtQybOrderDetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andRecIdIsNull() {
            addCriterion("rec_id is null");
            return (Criteria) this;
        }

        public Criteria andRecIdIsNotNull() {
            addCriterion("rec_id is not null");
            return (Criteria) this;
        }

        public Criteria andRecIdEqualTo(Integer value) {
            addCriterion("rec_id =", value, "recId");
            return (Criteria) this;
        }

        public Criteria andRecIdNotEqualTo(Integer value) {
            addCriterion("rec_id <>", value, "recId");
            return (Criteria) this;
        }

        public Criteria andRecIdGreaterThan(Integer value) {
            addCriterion("rec_id >", value, "recId");
            return (Criteria) this;
        }

        public Criteria andRecIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("rec_id >=", value, "recId");
            return (Criteria) this;
        }

        public Criteria andRecIdLessThan(Integer value) {
            addCriterion("rec_id <", value, "recId");
            return (Criteria) this;
        }

        public Criteria andRecIdLessThanOrEqualTo(Integer value) {
            addCriterion("rec_id <=", value, "recId");
            return (Criteria) this;
        }

        public Criteria andRecIdIn(List<Integer> values) {
            addCriterion("rec_id in", values, "recId");
            return (Criteria) this;
        }

        public Criteria andRecIdNotIn(List<Integer> values) {
            addCriterion("rec_id not in", values, "recId");
            return (Criteria) this;
        }

        public Criteria andRecIdBetween(Integer value1, Integer value2) {
            addCriterion("rec_id between", value1, value2, "recId");
            return (Criteria) this;
        }

        public Criteria andRecIdNotBetween(Integer value1, Integer value2) {
            addCriterion("rec_id not between", value1, value2, "recId");
            return (Criteria) this;
        }

        public Criteria andTradeIdIsNull() {
            addCriterion("trade_id is null");
            return (Criteria) this;
        }

        public Criteria andTradeIdIsNotNull() {
            addCriterion("trade_id is not null");
            return (Criteria) this;
        }

        public Criteria andTradeIdEqualTo(Integer value) {
            addCriterion("trade_id =", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdNotEqualTo(Integer value) {
            addCriterion("trade_id <>", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdGreaterThan(Integer value) {
            addCriterion("trade_id >", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("trade_id >=", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdLessThan(Integer value) {
            addCriterion("trade_id <", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdLessThanOrEqualTo(Integer value) {
            addCriterion("trade_id <=", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdIn(List<Integer> values) {
            addCriterion("trade_id in", values, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdNotIn(List<Integer> values) {
            addCriterion("trade_id not in", values, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdBetween(Integer value1, Integer value2) {
            addCriterion("trade_id between", value1, value2, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("trade_id not between", value1, value2, "tradeId");
            return (Criteria) this;
        }

        public Criteria andSpecIdIsNull() {
            addCriterion("spec_id is null");
            return (Criteria) this;
        }

        public Criteria andSpecIdIsNotNull() {
            addCriterion("spec_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpecIdEqualTo(Integer value) {
            addCriterion("spec_id =", value, "specId");
            return (Criteria) this;
        }

        public Criteria andSpecIdNotEqualTo(Integer value) {
            addCriterion("spec_id <>", value, "specId");
            return (Criteria) this;
        }

        public Criteria andSpecIdGreaterThan(Integer value) {
            addCriterion("spec_id >", value, "specId");
            return (Criteria) this;
        }

        public Criteria andSpecIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spec_id >=", value, "specId");
            return (Criteria) this;
        }

        public Criteria andSpecIdLessThan(Integer value) {
            addCriterion("spec_id <", value, "specId");
            return (Criteria) this;
        }

        public Criteria andSpecIdLessThanOrEqualTo(Integer value) {
            addCriterion("spec_id <=", value, "specId");
            return (Criteria) this;
        }

        public Criteria andSpecIdIn(List<Integer> values) {
            addCriterion("spec_id in", values, "specId");
            return (Criteria) this;
        }

        public Criteria andSpecIdNotIn(List<Integer> values) {
            addCriterion("spec_id not in", values, "specId");
            return (Criteria) this;
        }

        public Criteria andSpecIdBetween(Integer value1, Integer value2) {
            addCriterion("spec_id between", value1, value2, "specId");
            return (Criteria) this;
        }

        public Criteria andSpecIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spec_id not between", value1, value2, "specId");
            return (Criteria) this;
        }

        public Criteria andShopNoIsNull() {
            addCriterion("shop_no is null");
            return (Criteria) this;
        }

        public Criteria andShopNoIsNotNull() {
            addCriterion("shop_no is not null");
            return (Criteria) this;
        }

        public Criteria andShopNoEqualTo(String value) {
            addCriterion("shop_no =", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotEqualTo(String value) {
            addCriterion("shop_no <>", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoGreaterThan(String value) {
            addCriterion("shop_no >", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoGreaterThanOrEqualTo(String value) {
            addCriterion("shop_no >=", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoLessThan(String value) {
            addCriterion("shop_no <", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoLessThanOrEqualTo(String value) {
            addCriterion("shop_no <=", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoLike(String value) {
            addCriterion("shop_no like", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotLike(String value) {
            addCriterion("shop_no not like", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoIn(List<String> values) {
            addCriterion("shop_no in", values, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotIn(List<String> values) {
            addCriterion("shop_no not in", values, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoBetween(String value1, String value2) {
            addCriterion("shop_no between", value1, value2, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotBetween(String value1, String value2) {
            addCriterion("shop_no not between", value1, value2, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNull() {
            addCriterion("shop_name is null");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNotNull() {
            addCriterion("shop_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopNameEqualTo(String value) {
            addCriterion("shop_name =", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotEqualTo(String value) {
            addCriterion("shop_name <>", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThan(String value) {
            addCriterion("shop_name >", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("shop_name >=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThan(String value) {
            addCriterion("shop_name <", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThanOrEqualTo(String value) {
            addCriterion("shop_name <=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLike(String value) {
            addCriterion("shop_name like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotLike(String value) {
            addCriterion("shop_name not like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameIn(List<String> values) {
            addCriterion("shop_name in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotIn(List<String> values) {
            addCriterion("shop_name not in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameBetween(String value1, String value2) {
            addCriterion("shop_name between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotBetween(String value1, String value2) {
            addCriterion("shop_name not between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andPlatformIdIsNull() {
            addCriterion("platform_id is null");
            return (Criteria) this;
        }

        public Criteria andPlatformIdIsNotNull() {
            addCriterion("platform_id is not null");
            return (Criteria) this;
        }

        public Criteria andPlatformIdEqualTo(Integer value) {
            addCriterion("platform_id =", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotEqualTo(Integer value) {
            addCriterion("platform_id <>", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdGreaterThan(Integer value) {
            addCriterion("platform_id >", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("platform_id >=", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdLessThan(Integer value) {
            addCriterion("platform_id <", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdLessThanOrEqualTo(Integer value) {
            addCriterion("platform_id <=", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdIn(List<Integer> values) {
            addCriterion("platform_id in", values, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotIn(List<Integer> values) {
            addCriterion("platform_id not in", values, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdBetween(Integer value1, Integer value2) {
            addCriterion("platform_id between", value1, value2, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotBetween(Integer value1, Integer value2) {
            addCriterion("platform_id not between", value1, value2, "platformId");
            return (Criteria) this;
        }

        public Criteria andSrcOidIsNull() {
            addCriterion("src_oid is null");
            return (Criteria) this;
        }

        public Criteria andSrcOidIsNotNull() {
            addCriterion("src_oid is not null");
            return (Criteria) this;
        }

        public Criteria andSrcOidEqualTo(String value) {
            addCriterion("src_oid =", value, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidNotEqualTo(String value) {
            addCriterion("src_oid <>", value, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidGreaterThan(String value) {
            addCriterion("src_oid >", value, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidGreaterThanOrEqualTo(String value) {
            addCriterion("src_oid >=", value, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidLessThan(String value) {
            addCriterion("src_oid <", value, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidLessThanOrEqualTo(String value) {
            addCriterion("src_oid <=", value, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidLike(String value) {
            addCriterion("src_oid like", value, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidNotLike(String value) {
            addCriterion("src_oid not like", value, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidIn(List<String> values) {
            addCriterion("src_oid in", values, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidNotIn(List<String> values) {
            addCriterion("src_oid not in", values, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidBetween(String value1, String value2) {
            addCriterion("src_oid between", value1, value2, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSrcOidNotBetween(String value1, String value2) {
            addCriterion("src_oid not between", value1, value2, "srcOid");
            return (Criteria) this;
        }

        public Criteria andSuiteIdIsNull() {
            addCriterion("suite_id is null");
            return (Criteria) this;
        }

        public Criteria andSuiteIdIsNotNull() {
            addCriterion("suite_id is not null");
            return (Criteria) this;
        }

        public Criteria andSuiteIdEqualTo(Integer value) {
            addCriterion("suite_id =", value, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSuiteIdNotEqualTo(Integer value) {
            addCriterion("suite_id <>", value, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSuiteIdGreaterThan(Integer value) {
            addCriterion("suite_id >", value, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSuiteIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("suite_id >=", value, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSuiteIdLessThan(Integer value) {
            addCriterion("suite_id <", value, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSuiteIdLessThanOrEqualTo(Integer value) {
            addCriterion("suite_id <=", value, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSuiteIdIn(List<Integer> values) {
            addCriterion("suite_id in", values, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSuiteIdNotIn(List<Integer> values) {
            addCriterion("suite_id not in", values, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSuiteIdBetween(Integer value1, Integer value2) {
            addCriterion("suite_id between", value1, value2, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSuiteIdNotBetween(Integer value1, Integer value2) {
            addCriterion("suite_id not between", value1, value2, "suiteId");
            return (Criteria) this;
        }

        public Criteria andSrcTidIsNull() {
            addCriterion("src_tid is null");
            return (Criteria) this;
        }

        public Criteria andSrcTidIsNotNull() {
            addCriterion("src_tid is not null");
            return (Criteria) this;
        }

        public Criteria andSrcTidEqualTo(String value) {
            addCriterion("src_tid =", value, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidNotEqualTo(String value) {
            addCriterion("src_tid <>", value, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidGreaterThan(String value) {
            addCriterion("src_tid >", value, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidGreaterThanOrEqualTo(String value) {
            addCriterion("src_tid >=", value, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidLessThan(String value) {
            addCriterion("src_tid <", value, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidLessThanOrEqualTo(String value) {
            addCriterion("src_tid <=", value, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidLike(String value) {
            addCriterion("src_tid like", value, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidNotLike(String value) {
            addCriterion("src_tid not like", value, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidIn(List<String> values) {
            addCriterion("src_tid in", values, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidNotIn(List<String> values) {
            addCriterion("src_tid not in", values, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidBetween(String value1, String value2) {
            addCriterion("src_tid between", value1, value2, "srcTid");
            return (Criteria) this;
        }

        public Criteria andSrcTidNotBetween(String value1, String value2) {
            addCriterion("src_tid not between", value1, value2, "srcTid");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintIsNull() {
            addCriterion("gift_typeint is null");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintIsNotNull() {
            addCriterion("gift_typeint is not null");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintEqualTo(Integer value) {
            addCriterion("gift_typeint =", value, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintNotEqualTo(Integer value) {
            addCriterion("gift_typeint <>", value, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintGreaterThan(Integer value) {
            addCriterion("gift_typeint >", value, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintGreaterThanOrEqualTo(Integer value) {
            addCriterion("gift_typeint >=", value, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintLessThan(Integer value) {
            addCriterion("gift_typeint <", value, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintLessThanOrEqualTo(Integer value) {
            addCriterion("gift_typeint <=", value, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintIn(List<Integer> values) {
            addCriterion("gift_typeint in", values, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintNotIn(List<Integer> values) {
            addCriterion("gift_typeint not in", values, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintBetween(Integer value1, Integer value2) {
            addCriterion("gift_typeint between", value1, value2, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andGiftTypeintNotBetween(Integer value1, Integer value2) {
            addCriterion("gift_typeint not between", value1, value2, "giftTypeint");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNull() {
            addCriterion("refund_status is null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNotNull() {
            addCriterion("refund_status is not null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusEqualTo(Integer value) {
            addCriterion("refund_status =", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotEqualTo(Integer value) {
            addCriterion("refund_status <>", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThan(Integer value) {
            addCriterion("refund_status >", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("refund_status >=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThan(Integer value) {
            addCriterion("refund_status <", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThanOrEqualTo(Integer value) {
            addCriterion("refund_status <=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIn(List<Integer> values) {
            addCriterion("refund_status in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotIn(List<Integer> values) {
            addCriterion("refund_status not in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusBetween(Integer value1, Integer value2) {
            addCriterion("refund_status between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("refund_status not between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeIsNull() {
            addCriterion("guarantee_mode is null");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeIsNotNull() {
            addCriterion("guarantee_mode is not null");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeEqualTo(Integer value) {
            addCriterion("guarantee_mode =", value, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeNotEqualTo(Integer value) {
            addCriterion("guarantee_mode <>", value, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeGreaterThan(Integer value) {
            addCriterion("guarantee_mode >", value, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeGreaterThanOrEqualTo(Integer value) {
            addCriterion("guarantee_mode >=", value, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeLessThan(Integer value) {
            addCriterion("guarantee_mode <", value, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeLessThanOrEqualTo(Integer value) {
            addCriterion("guarantee_mode <=", value, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeIn(List<Integer> values) {
            addCriterion("guarantee_mode in", values, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeNotIn(List<Integer> values) {
            addCriterion("guarantee_mode not in", values, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeBetween(Integer value1, Integer value2) {
            addCriterion("guarantee_mode between", value1, value2, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andGuaranteeModeNotBetween(Integer value1, Integer value2) {
            addCriterion("guarantee_mode not between", value1, value2, "guaranteeMode");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermIsNull() {
            addCriterion("delivery_term is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermIsNotNull() {
            addCriterion("delivery_term is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermEqualTo(Integer value) {
            addCriterion("delivery_term =", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermNotEqualTo(Integer value) {
            addCriterion("delivery_term <>", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermGreaterThan(Integer value) {
            addCriterion("delivery_term >", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermGreaterThanOrEqualTo(Integer value) {
            addCriterion("delivery_term >=", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermLessThan(Integer value) {
            addCriterion("delivery_term <", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermLessThanOrEqualTo(Integer value) {
            addCriterion("delivery_term <=", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermIn(List<Integer> values) {
            addCriterion("delivery_term in", values, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermNotIn(List<Integer> values) {
            addCriterion("delivery_term not in", values, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermBetween(Integer value1, Integer value2) {
            addCriterion("delivery_term between", value1, value2, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermNotBetween(Integer value1, Integer value2) {
            addCriterion("delivery_term not between", value1, value2, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andBindOidIsNull() {
            addCriterion("bind_oid is null");
            return (Criteria) this;
        }

        public Criteria andBindOidIsNotNull() {
            addCriterion("bind_oid is not null");
            return (Criteria) this;
        }

        public Criteria andBindOidEqualTo(String value) {
            addCriterion("bind_oid =", value, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidNotEqualTo(String value) {
            addCriterion("bind_oid <>", value, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidGreaterThan(String value) {
            addCriterion("bind_oid >", value, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidGreaterThanOrEqualTo(String value) {
            addCriterion("bind_oid >=", value, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidLessThan(String value) {
            addCriterion("bind_oid <", value, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidLessThanOrEqualTo(String value) {
            addCriterion("bind_oid <=", value, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidLike(String value) {
            addCriterion("bind_oid like", value, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidNotLike(String value) {
            addCriterion("bind_oid not like", value, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidIn(List<String> values) {
            addCriterion("bind_oid in", values, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidNotIn(List<String> values) {
            addCriterion("bind_oid not in", values, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidBetween(String value1, String value2) {
            addCriterion("bind_oid between", value1, value2, "bindOid");
            return (Criteria) this;
        }

        public Criteria andBindOidNotBetween(String value1, String value2) {
            addCriterion("bind_oid not between", value1, value2, "bindOid");
            return (Criteria) this;
        }

        public Criteria andNumIsNull() {
            addCriterion("num is null");
            return (Criteria) this;
        }

        public Criteria andNumIsNotNull() {
            addCriterion("num is not null");
            return (Criteria) this;
        }

        public Criteria andNumEqualTo(BigDecimal value) {
            addCriterion("num =", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotEqualTo(BigDecimal value) {
            addCriterion("num <>", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumGreaterThan(BigDecimal value) {
            addCriterion("num >", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("num >=", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumLessThan(BigDecimal value) {
            addCriterion("num <", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("num <=", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumIn(List<BigDecimal> values) {
            addCriterion("num in", values, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotIn(List<BigDecimal> values) {
            addCriterion("num not in", values, "num");
            return (Criteria) this;
        }

        public Criteria andNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("num between", value1, value2, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("num not between", value1, value2, "num");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andActualNumIsNull() {
            addCriterion("actual_num is null");
            return (Criteria) this;
        }

        public Criteria andActualNumIsNotNull() {
            addCriterion("actual_num is not null");
            return (Criteria) this;
        }

        public Criteria andActualNumEqualTo(BigDecimal value) {
            addCriterion("actual_num =", value, "actualNum");
            return (Criteria) this;
        }

        public Criteria andActualNumNotEqualTo(BigDecimal value) {
            addCriterion("actual_num <>", value, "actualNum");
            return (Criteria) this;
        }

        public Criteria andActualNumGreaterThan(BigDecimal value) {
            addCriterion("actual_num >", value, "actualNum");
            return (Criteria) this;
        }

        public Criteria andActualNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("actual_num >=", value, "actualNum");
            return (Criteria) this;
        }

        public Criteria andActualNumLessThan(BigDecimal value) {
            addCriterion("actual_num <", value, "actualNum");
            return (Criteria) this;
        }

        public Criteria andActualNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("actual_num <=", value, "actualNum");
            return (Criteria) this;
        }

        public Criteria andActualNumIn(List<BigDecimal> values) {
            addCriterion("actual_num in", values, "actualNum");
            return (Criteria) this;
        }

        public Criteria andActualNumNotIn(List<BigDecimal> values) {
            addCriterion("actual_num not in", values, "actualNum");
            return (Criteria) this;
        }

        public Criteria andActualNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("actual_num between", value1, value2, "actualNum");
            return (Criteria) this;
        }

        public Criteria andActualNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("actual_num not between", value1, value2, "actualNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumIsNull() {
            addCriterion("refund_num is null");
            return (Criteria) this;
        }

        public Criteria andRefundNumIsNotNull() {
            addCriterion("refund_num is not null");
            return (Criteria) this;
        }

        public Criteria andRefundNumEqualTo(BigDecimal value) {
            addCriterion("refund_num =", value, "refundNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumNotEqualTo(BigDecimal value) {
            addCriterion("refund_num <>", value, "refundNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumGreaterThan(BigDecimal value) {
            addCriterion("refund_num >", value, "refundNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("refund_num >=", value, "refundNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumLessThan(BigDecimal value) {
            addCriterion("refund_num <", value, "refundNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("refund_num <=", value, "refundNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumIn(List<BigDecimal> values) {
            addCriterion("refund_num in", values, "refundNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumNotIn(List<BigDecimal> values) {
            addCriterion("refund_num not in", values, "refundNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("refund_num between", value1, value2, "refundNum");
            return (Criteria) this;
        }

        public Criteria andRefundNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("refund_num not between", value1, value2, "refundNum");
            return (Criteria) this;
        }

        public Criteria andOrderPriceIsNull() {
            addCriterion("order_price is null");
            return (Criteria) this;
        }

        public Criteria andOrderPriceIsNotNull() {
            addCriterion("order_price is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPriceEqualTo(BigDecimal value) {
            addCriterion("order_price =", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotEqualTo(BigDecimal value) {
            addCriterion("order_price <>", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceGreaterThan(BigDecimal value) {
            addCriterion("order_price >", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_price >=", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceLessThan(BigDecimal value) {
            addCriterion("order_price <", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_price <=", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceIn(List<BigDecimal> values) {
            addCriterion("order_price in", values, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotIn(List<BigDecimal> values) {
            addCriterion("order_price not in", values, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_price between", value1, value2, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_price not between", value1, value2, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceIsNull() {
            addCriterion("share_price is null");
            return (Criteria) this;
        }

        public Criteria andSharePriceIsNotNull() {
            addCriterion("share_price is not null");
            return (Criteria) this;
        }

        public Criteria andSharePriceEqualTo(BigDecimal value) {
            addCriterion("share_price =", value, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceNotEqualTo(BigDecimal value) {
            addCriterion("share_price <>", value, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceGreaterThan(BigDecimal value) {
            addCriterion("share_price >", value, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("share_price >=", value, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceLessThan(BigDecimal value) {
            addCriterion("share_price <", value, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("share_price <=", value, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceIn(List<BigDecimal> values) {
            addCriterion("share_price in", values, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceNotIn(List<BigDecimal> values) {
            addCriterion("share_price not in", values, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_price between", value1, value2, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andSharePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_price not between", value1, value2, "sharePrice");
            return (Criteria) this;
        }

        public Criteria andAdjustIsNull() {
            addCriterion("adjust is null");
            return (Criteria) this;
        }

        public Criteria andAdjustIsNotNull() {
            addCriterion("adjust is not null");
            return (Criteria) this;
        }

        public Criteria andAdjustEqualTo(BigDecimal value) {
            addCriterion("adjust =", value, "adjust");
            return (Criteria) this;
        }

        public Criteria andAdjustNotEqualTo(BigDecimal value) {
            addCriterion("adjust <>", value, "adjust");
            return (Criteria) this;
        }

        public Criteria andAdjustGreaterThan(BigDecimal value) {
            addCriterion("adjust >", value, "adjust");
            return (Criteria) this;
        }

        public Criteria andAdjustGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("adjust >=", value, "adjust");
            return (Criteria) this;
        }

        public Criteria andAdjustLessThan(BigDecimal value) {
            addCriterion("adjust <", value, "adjust");
            return (Criteria) this;
        }

        public Criteria andAdjustLessThanOrEqualTo(BigDecimal value) {
            addCriterion("adjust <=", value, "adjust");
            return (Criteria) this;
        }

        public Criteria andAdjustIn(List<BigDecimal> values) {
            addCriterion("adjust in", values, "adjust");
            return (Criteria) this;
        }

        public Criteria andAdjustNotIn(List<BigDecimal> values) {
            addCriterion("adjust not in", values, "adjust");
            return (Criteria) this;
        }

        public Criteria andAdjustBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("adjust between", value1, value2, "adjust");
            return (Criteria) this;
        }

        public Criteria andAdjustNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("adjust not between", value1, value2, "adjust");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("discount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("discount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(BigDecimal value) {
            addCriterion("discount =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(BigDecimal value) {
            addCriterion("discount <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(BigDecimal value) {
            addCriterion("discount >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discount >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(BigDecimal value) {
            addCriterion("discount <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discount <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<BigDecimal> values) {
            addCriterion("discount in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<BigDecimal> values) {
            addCriterion("discount not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andShareAmountIsNull() {
            addCriterion("share_amount is null");
            return (Criteria) this;
        }

        public Criteria andShareAmountIsNotNull() {
            addCriterion("share_amount is not null");
            return (Criteria) this;
        }

        public Criteria andShareAmountEqualTo(BigDecimal value) {
            addCriterion("share_amount =", value, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andShareAmountNotEqualTo(BigDecimal value) {
            addCriterion("share_amount <>", value, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andShareAmountGreaterThan(BigDecimal value) {
            addCriterion("share_amount >", value, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andShareAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("share_amount >=", value, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andShareAmountLessThan(BigDecimal value) {
            addCriterion("share_amount <", value, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andShareAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("share_amount <=", value, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andShareAmountIn(List<BigDecimal> values) {
            addCriterion("share_amount in", values, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andShareAmountNotIn(List<BigDecimal> values) {
            addCriterion("share_amount not in", values, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andShareAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_amount between", value1, value2, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andShareAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_amount not between", value1, value2, "shareAmount");
            return (Criteria) this;
        }

        public Criteria andSharePostIsNull() {
            addCriterion("share_post is null");
            return (Criteria) this;
        }

        public Criteria andSharePostIsNotNull() {
            addCriterion("share_post is not null");
            return (Criteria) this;
        }

        public Criteria andSharePostEqualTo(BigDecimal value) {
            addCriterion("share_post =", value, "sharePost");
            return (Criteria) this;
        }

        public Criteria andSharePostNotEqualTo(BigDecimal value) {
            addCriterion("share_post <>", value, "sharePost");
            return (Criteria) this;
        }

        public Criteria andSharePostGreaterThan(BigDecimal value) {
            addCriterion("share_post >", value, "sharePost");
            return (Criteria) this;
        }

        public Criteria andSharePostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("share_post >=", value, "sharePost");
            return (Criteria) this;
        }

        public Criteria andSharePostLessThan(BigDecimal value) {
            addCriterion("share_post <", value, "sharePost");
            return (Criteria) this;
        }

        public Criteria andSharePostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("share_post <=", value, "sharePost");
            return (Criteria) this;
        }

        public Criteria andSharePostIn(List<BigDecimal> values) {
            addCriterion("share_post in", values, "sharePost");
            return (Criteria) this;
        }

        public Criteria andSharePostNotIn(List<BigDecimal> values) {
            addCriterion("share_post not in", values, "sharePost");
            return (Criteria) this;
        }

        public Criteria andSharePostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_post between", value1, value2, "sharePost");
            return (Criteria) this;
        }

        public Criteria andSharePostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("share_post not between", value1, value2, "sharePost");
            return (Criteria) this;
        }

        public Criteria andPaidIsNull() {
            addCriterion("paid is null");
            return (Criteria) this;
        }

        public Criteria andPaidIsNotNull() {
            addCriterion("paid is not null");
            return (Criteria) this;
        }

        public Criteria andPaidEqualTo(BigDecimal value) {
            addCriterion("paid =", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidNotEqualTo(BigDecimal value) {
            addCriterion("paid <>", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidGreaterThan(BigDecimal value) {
            addCriterion("paid >", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("paid >=", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidLessThan(BigDecimal value) {
            addCriterion("paid <", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("paid <=", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidIn(List<BigDecimal> values) {
            addCriterion("paid in", values, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidNotIn(List<BigDecimal> values) {
            addCriterion("paid not in", values, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid between", value1, value2, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid not between", value1, value2, "paid");
            return (Criteria) this;
        }

        public Criteria andGoodsNameIsNull() {
            addCriterion("goods_name is null");
            return (Criteria) this;
        }

        public Criteria andGoodsNameIsNotNull() {
            addCriterion("goods_name is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsNameEqualTo(String value) {
            addCriterion("goods_name =", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotEqualTo(String value) {
            addCriterion("goods_name <>", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameGreaterThan(String value) {
            addCriterion("goods_name >", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameGreaterThanOrEqualTo(String value) {
            addCriterion("goods_name >=", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameLessThan(String value) {
            addCriterion("goods_name <", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameLessThanOrEqualTo(String value) {
            addCriterion("goods_name <=", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameLike(String value) {
            addCriterion("goods_name like", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotLike(String value) {
            addCriterion("goods_name not like", value, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameIn(List<String> values) {
            addCriterion("goods_name in", values, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotIn(List<String> values) {
            addCriterion("goods_name not in", values, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameBetween(String value1, String value2) {
            addCriterion("goods_name between", value1, value2, "goodsName");
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotBetween(String value1, String value2) {
            addCriterion("goods_name not between", value1, value2, "goodsName");
            return (Criteria) this;
        }

        public Criteria andProp2IsNull() {
            addCriterion("prop2 is null");
            return (Criteria) this;
        }

        public Criteria andProp2IsNotNull() {
            addCriterion("prop2 is not null");
            return (Criteria) this;
        }

        public Criteria andProp2EqualTo(String value) {
            addCriterion("prop2 =", value, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2NotEqualTo(String value) {
            addCriterion("prop2 <>", value, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2GreaterThan(String value) {
            addCriterion("prop2 >", value, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2GreaterThanOrEqualTo(String value) {
            addCriterion("prop2 >=", value, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2LessThan(String value) {
            addCriterion("prop2 <", value, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2LessThanOrEqualTo(String value) {
            addCriterion("prop2 <=", value, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2Like(String value) {
            addCriterion("prop2 like", value, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2NotLike(String value) {
            addCriterion("prop2 not like", value, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2In(List<String> values) {
            addCriterion("prop2 in", values, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2NotIn(List<String> values) {
            addCriterion("prop2 not in", values, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2Between(String value1, String value2) {
            addCriterion("prop2 between", value1, value2, "prop2");
            return (Criteria) this;
        }

        public Criteria andProp2NotBetween(String value1, String value2) {
            addCriterion("prop2 not between", value1, value2, "prop2");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNull() {
            addCriterion("goods_id is null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNotNull() {
            addCriterion("goods_id is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualTo(Integer value) {
            addCriterion("goods_id =", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualTo(Integer value) {
            addCriterion("goods_id <>", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThan(Integer value) {
            addCriterion("goods_id >", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("goods_id >=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThan(Integer value) {
            addCriterion("goods_id <", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("goods_id <=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIn(List<Integer> values) {
            addCriterion("goods_id in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotIn(List<Integer> values) {
            addCriterion("goods_id not in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("goods_id between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("goods_id not between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsNoIsNull() {
            addCriterion("goods_no is null");
            return (Criteria) this;
        }

        public Criteria andGoodsNoIsNotNull() {
            addCriterion("goods_no is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsNoEqualTo(String value) {
            addCriterion("goods_no =", value, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoNotEqualTo(String value) {
            addCriterion("goods_no <>", value, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoGreaterThan(String value) {
            addCriterion("goods_no >", value, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoGreaterThanOrEqualTo(String value) {
            addCriterion("goods_no >=", value, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoLessThan(String value) {
            addCriterion("goods_no <", value, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoLessThanOrEqualTo(String value) {
            addCriterion("goods_no <=", value, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoLike(String value) {
            addCriterion("goods_no like", value, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoNotLike(String value) {
            addCriterion("goods_no not like", value, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoIn(List<String> values) {
            addCriterion("goods_no in", values, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoNotIn(List<String> values) {
            addCriterion("goods_no not in", values, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoBetween(String value1, String value2) {
            addCriterion("goods_no between", value1, value2, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andGoodsNoNotBetween(String value1, String value2) {
            addCriterion("goods_no not between", value1, value2, "goodsNo");
            return (Criteria) this;
        }

        public Criteria andSpecNameIsNull() {
            addCriterion("spec_name is null");
            return (Criteria) this;
        }

        public Criteria andSpecNameIsNotNull() {
            addCriterion("spec_name is not null");
            return (Criteria) this;
        }

        public Criteria andSpecNameEqualTo(String value) {
            addCriterion("spec_name =", value, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameNotEqualTo(String value) {
            addCriterion("spec_name <>", value, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameGreaterThan(String value) {
            addCriterion("spec_name >", value, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameGreaterThanOrEqualTo(String value) {
            addCriterion("spec_name >=", value, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameLessThan(String value) {
            addCriterion("spec_name <", value, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameLessThanOrEqualTo(String value) {
            addCriterion("spec_name <=", value, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameLike(String value) {
            addCriterion("spec_name like", value, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameNotLike(String value) {
            addCriterion("spec_name not like", value, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameIn(List<String> values) {
            addCriterion("spec_name in", values, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameNotIn(List<String> values) {
            addCriterion("spec_name not in", values, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameBetween(String value1, String value2) {
            addCriterion("spec_name between", value1, value2, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNameNotBetween(String value1, String value2) {
            addCriterion("spec_name not between", value1, value2, "specName");
            return (Criteria) this;
        }

        public Criteria andSpecNoIsNull() {
            addCriterion("spec_no is null");
            return (Criteria) this;
        }

        public Criteria andSpecNoIsNotNull() {
            addCriterion("spec_no is not null");
            return (Criteria) this;
        }

        public Criteria andSpecNoEqualTo(String value) {
            addCriterion("spec_no =", value, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoNotEqualTo(String value) {
            addCriterion("spec_no <>", value, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoGreaterThan(String value) {
            addCriterion("spec_no >", value, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoGreaterThanOrEqualTo(String value) {
            addCriterion("spec_no >=", value, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoLessThan(String value) {
            addCriterion("spec_no <", value, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoLessThanOrEqualTo(String value) {
            addCriterion("spec_no <=", value, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoLike(String value) {
            addCriterion("spec_no like", value, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoNotLike(String value) {
            addCriterion("spec_no not like", value, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoIn(List<String> values) {
            addCriterion("spec_no in", values, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoNotIn(List<String> values) {
            addCriterion("spec_no not in", values, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoBetween(String value1, String value2) {
            addCriterion("spec_no between", value1, value2, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecNoNotBetween(String value1, String value2) {
            addCriterion("spec_no not between", value1, value2, "specNo");
            return (Criteria) this;
        }

        public Criteria andSpecCodeIsNull() {
            addCriterion("spec_code is null");
            return (Criteria) this;
        }

        public Criteria andSpecCodeIsNotNull() {
            addCriterion("spec_code is not null");
            return (Criteria) this;
        }

        public Criteria andSpecCodeEqualTo(String value) {
            addCriterion("spec_code =", value, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeNotEqualTo(String value) {
            addCriterion("spec_code <>", value, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeGreaterThan(String value) {
            addCriterion("spec_code >", value, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeGreaterThanOrEqualTo(String value) {
            addCriterion("spec_code >=", value, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeLessThan(String value) {
            addCriterion("spec_code <", value, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeLessThanOrEqualTo(String value) {
            addCriterion("spec_code <=", value, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeLike(String value) {
            addCriterion("spec_code like", value, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeNotLike(String value) {
            addCriterion("spec_code not like", value, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeIn(List<String> values) {
            addCriterion("spec_code in", values, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeNotIn(List<String> values) {
            addCriterion("spec_code not in", values, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeBetween(String value1, String value2) {
            addCriterion("spec_code between", value1, value2, "specCode");
            return (Criteria) this;
        }

        public Criteria andSpecCodeNotBetween(String value1, String value2) {
            addCriterion("spec_code not between", value1, value2, "specCode");
            return (Criteria) this;
        }

        public Criteria andSuiteNoIsNull() {
            addCriterion("suite_no is null");
            return (Criteria) this;
        }

        public Criteria andSuiteNoIsNotNull() {
            addCriterion("suite_no is not null");
            return (Criteria) this;
        }

        public Criteria andSuiteNoEqualTo(String value) {
            addCriterion("suite_no =", value, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoNotEqualTo(String value) {
            addCriterion("suite_no <>", value, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoGreaterThan(String value) {
            addCriterion("suite_no >", value, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoGreaterThanOrEqualTo(String value) {
            addCriterion("suite_no >=", value, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoLessThan(String value) {
            addCriterion("suite_no <", value, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoLessThanOrEqualTo(String value) {
            addCriterion("suite_no <=", value, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoLike(String value) {
            addCriterion("suite_no like", value, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoNotLike(String value) {
            addCriterion("suite_no not like", value, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoIn(List<String> values) {
            addCriterion("suite_no in", values, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoNotIn(List<String> values) {
            addCriterion("suite_no not in", values, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoBetween(String value1, String value2) {
            addCriterion("suite_no between", value1, value2, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNoNotBetween(String value1, String value2) {
            addCriterion("suite_no not between", value1, value2, "suiteNo");
            return (Criteria) this;
        }

        public Criteria andSuiteNameIsNull() {
            addCriterion("suite_name is null");
            return (Criteria) this;
        }

        public Criteria andSuiteNameIsNotNull() {
            addCriterion("suite_name is not null");
            return (Criteria) this;
        }

        public Criteria andSuiteNameEqualTo(String value) {
            addCriterion("suite_name =", value, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameNotEqualTo(String value) {
            addCriterion("suite_name <>", value, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameGreaterThan(String value) {
            addCriterion("suite_name >", value, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameGreaterThanOrEqualTo(String value) {
            addCriterion("suite_name >=", value, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameLessThan(String value) {
            addCriterion("suite_name <", value, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameLessThanOrEqualTo(String value) {
            addCriterion("suite_name <=", value, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameLike(String value) {
            addCriterion("suite_name like", value, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameNotLike(String value) {
            addCriterion("suite_name not like", value, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameIn(List<String> values) {
            addCriterion("suite_name in", values, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameNotIn(List<String> values) {
            addCriterion("suite_name not in", values, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameBetween(String value1, String value2) {
            addCriterion("suite_name between", value1, value2, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNameNotBetween(String value1, String value2) {
            addCriterion("suite_name not between", value1, value2, "suiteName");
            return (Criteria) this;
        }

        public Criteria andSuiteNumIsNull() {
            addCriterion("suite_num is null");
            return (Criteria) this;
        }

        public Criteria andSuiteNumIsNotNull() {
            addCriterion("suite_num is not null");
            return (Criteria) this;
        }

        public Criteria andSuiteNumEqualTo(BigDecimal value) {
            addCriterion("suite_num =", value, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteNumNotEqualTo(BigDecimal value) {
            addCriterion("suite_num <>", value, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteNumGreaterThan(BigDecimal value) {
            addCriterion("suite_num >", value, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("suite_num >=", value, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteNumLessThan(BigDecimal value) {
            addCriterion("suite_num <", value, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("suite_num <=", value, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteNumIn(List<BigDecimal> values) {
            addCriterion("suite_num in", values, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteNumNotIn(List<BigDecimal> values) {
            addCriterion("suite_num not in", values, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("suite_num between", value1, value2, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("suite_num not between", value1, value2, "suiteNum");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountIsNull() {
            addCriterion("suite_amount is null");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountIsNotNull() {
            addCriterion("suite_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountEqualTo(BigDecimal value) {
            addCriterion("suite_amount =", value, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountNotEqualTo(BigDecimal value) {
            addCriterion("suite_amount <>", value, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountGreaterThan(BigDecimal value) {
            addCriterion("suite_amount >", value, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("suite_amount >=", value, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountLessThan(BigDecimal value) {
            addCriterion("suite_amount <", value, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("suite_amount <=", value, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountIn(List<BigDecimal> values) {
            addCriterion("suite_amount in", values, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountNotIn(List<BigDecimal> values) {
            addCriterion("suite_amount not in", values, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("suite_amount between", value1, value2, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("suite_amount not between", value1, value2, "suiteAmount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountIsNull() {
            addCriterion("suite_discount is null");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountIsNotNull() {
            addCriterion("suite_discount is not null");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountEqualTo(BigDecimal value) {
            addCriterion("suite_discount =", value, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountNotEqualTo(BigDecimal value) {
            addCriterion("suite_discount <>", value, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountGreaterThan(BigDecimal value) {
            addCriterion("suite_discount >", value, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("suite_discount >=", value, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountLessThan(BigDecimal value) {
            addCriterion("suite_discount <", value, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("suite_discount <=", value, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountIn(List<BigDecimal> values) {
            addCriterion("suite_discount in", values, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountNotIn(List<BigDecimal> values) {
            addCriterion("suite_discount not in", values, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("suite_discount between", value1, value2, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andSuiteDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("suite_discount not between", value1, value2, "suiteDiscount");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameIsNull() {
            addCriterion("api_goods_name is null");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameIsNotNull() {
            addCriterion("api_goods_name is not null");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameEqualTo(String value) {
            addCriterion("api_goods_name =", value, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameNotEqualTo(String value) {
            addCriterion("api_goods_name <>", value, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameGreaterThan(String value) {
            addCriterion("api_goods_name >", value, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameGreaterThanOrEqualTo(String value) {
            addCriterion("api_goods_name >=", value, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameLessThan(String value) {
            addCriterion("api_goods_name <", value, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameLessThanOrEqualTo(String value) {
            addCriterion("api_goods_name <=", value, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameLike(String value) {
            addCriterion("api_goods_name like", value, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameNotLike(String value) {
            addCriterion("api_goods_name not like", value, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameIn(List<String> values) {
            addCriterion("api_goods_name in", values, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameNotIn(List<String> values) {
            addCriterion("api_goods_name not in", values, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameBetween(String value1, String value2) {
            addCriterion("api_goods_name between", value1, value2, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiGoodsNameNotBetween(String value1, String value2) {
            addCriterion("api_goods_name not between", value1, value2, "apiGoodsName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameIsNull() {
            addCriterion("api_spec_name is null");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameIsNotNull() {
            addCriterion("api_spec_name is not null");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameEqualTo(String value) {
            addCriterion("api_spec_name =", value, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameNotEqualTo(String value) {
            addCriterion("api_spec_name <>", value, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameGreaterThan(String value) {
            addCriterion("api_spec_name >", value, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameGreaterThanOrEqualTo(String value) {
            addCriterion("api_spec_name >=", value, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameLessThan(String value) {
            addCriterion("api_spec_name <", value, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameLessThanOrEqualTo(String value) {
            addCriterion("api_spec_name <=", value, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameLike(String value) {
            addCriterion("api_spec_name like", value, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameNotLike(String value) {
            addCriterion("api_spec_name not like", value, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameIn(List<String> values) {
            addCriterion("api_spec_name in", values, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameNotIn(List<String> values) {
            addCriterion("api_spec_name not in", values, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameBetween(String value1, String value2) {
            addCriterion("api_spec_name between", value1, value2, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andApiSpecNameNotBetween(String value1, String value2) {
            addCriterion("api_spec_name not between", value1, value2, "apiSpecName");
            return (Criteria) this;
        }

        public Criteria andWeightIsNull() {
            addCriterion("weight is null");
            return (Criteria) this;
        }

        public Criteria andWeightIsNotNull() {
            addCriterion("weight is not null");
            return (Criteria) this;
        }

        public Criteria andWeightEqualTo(BigDecimal value) {
            addCriterion("weight =", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualTo(BigDecimal value) {
            addCriterion("weight <>", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThan(BigDecimal value) {
            addCriterion("weight >", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("weight >=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThan(BigDecimal value) {
            addCriterion("weight <", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("weight <=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightIn(List<BigDecimal> values) {
            addCriterion("weight in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotIn(List<BigDecimal> values) {
            addCriterion("weight not in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("weight between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("weight not between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNull() {
            addCriterion("commission is null");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNotNull() {
            addCriterion("commission is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionEqualTo(BigDecimal value) {
            addCriterion("commission =", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotEqualTo(BigDecimal value) {
            addCriterion("commission <>", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThan(BigDecimal value) {
            addCriterion("commission >", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("commission >=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThan(BigDecimal value) {
            addCriterion("commission <", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThanOrEqualTo(BigDecimal value) {
            addCriterion("commission <=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionIn(List<BigDecimal> values) {
            addCriterion("commission in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotIn(List<BigDecimal> values) {
            addCriterion("commission not in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commission between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commission not between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeIsNull() {
            addCriterion("goods_type is null");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeIsNotNull() {
            addCriterion("goods_type is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeEqualTo(Integer value) {
            addCriterion("goods_type =", value, "goodsType");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeNotEqualTo(Integer value) {
            addCriterion("goods_type <>", value, "goodsType");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeGreaterThan(Integer value) {
            addCriterion("goods_type >", value, "goodsType");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("goods_type >=", value, "goodsType");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeLessThan(Integer value) {
            addCriterion("goods_type <", value, "goodsType");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeLessThanOrEqualTo(Integer value) {
            addCriterion("goods_type <=", value, "goodsType");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeIn(List<Integer> values) {
            addCriterion("goods_type in", values, "goodsType");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeNotIn(List<Integer> values) {
            addCriterion("goods_type not in", values, "goodsType");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeBetween(Integer value1, Integer value2) {
            addCriterion("goods_type between", value1, value2, "goodsType");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("goods_type not between", value1, value2, "goodsType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeIsNull() {
            addCriterion("large_type is null");
            return (Criteria) this;
        }

        public Criteria andLargeTypeIsNotNull() {
            addCriterion("large_type is not null");
            return (Criteria) this;
        }

        public Criteria andLargeTypeEqualTo(Integer value) {
            addCriterion("large_type =", value, "largeType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeNotEqualTo(Integer value) {
            addCriterion("large_type <>", value, "largeType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeGreaterThan(Integer value) {
            addCriterion("large_type >", value, "largeType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("large_type >=", value, "largeType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeLessThan(Integer value) {
            addCriterion("large_type <", value, "largeType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeLessThanOrEqualTo(Integer value) {
            addCriterion("large_type <=", value, "largeType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeIn(List<Integer> values) {
            addCriterion("large_type in", values, "largeType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeNotIn(List<Integer> values) {
            addCriterion("large_type not in", values, "largeType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeBetween(Integer value1, Integer value2) {
            addCriterion("large_type between", value1, value2, "largeType");
            return (Criteria) this;
        }

        public Criteria andLargeTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("large_type not between", value1, value2, "largeType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNull() {
            addCriterion("invoice_type is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNotNull() {
            addCriterion("invoice_type is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeEqualTo(Integer value) {
            addCriterion("invoice_type =", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotEqualTo(Integer value) {
            addCriterion("invoice_type <>", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThan(Integer value) {
            addCriterion("invoice_type >", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_type >=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThan(Integer value) {
            addCriterion("invoice_type <", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_type <=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIn(List<Integer> values) {
            addCriterion("invoice_type in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotIn(List<Integer> values) {
            addCriterion("invoice_type not in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeBetween(Integer value1, Integer value2) {
            addCriterion("invoice_type between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_type not between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentIsNull() {
            addCriterion("invoice_content is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentIsNotNull() {
            addCriterion("invoice_content is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentEqualTo(String value) {
            addCriterion("invoice_content =", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotEqualTo(String value) {
            addCriterion("invoice_content <>", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentGreaterThan(String value) {
            addCriterion("invoice_content >", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentGreaterThanOrEqualTo(String value) {
            addCriterion("invoice_content >=", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentLessThan(String value) {
            addCriterion("invoice_content <", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentLessThanOrEqualTo(String value) {
            addCriterion("invoice_content <=", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentLike(String value) {
            addCriterion("invoice_content like", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotLike(String value) {
            addCriterion("invoice_content not like", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentIn(List<String> values) {
            addCriterion("invoice_content in", values, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotIn(List<String> values) {
            addCriterion("invoice_content not in", values, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentBetween(String value1, String value2) {
            addCriterion("invoice_content between", value1, value2, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotBetween(String value1, String value2) {
            addCriterion("invoice_content not between", value1, value2, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andFromMaskIsNull() {
            addCriterion("from_mask is null");
            return (Criteria) this;
        }

        public Criteria andFromMaskIsNotNull() {
            addCriterion("from_mask is not null");
            return (Criteria) this;
        }

        public Criteria andFromMaskEqualTo(Integer value) {
            addCriterion("from_mask =", value, "fromMask");
            return (Criteria) this;
        }

        public Criteria andFromMaskNotEqualTo(Integer value) {
            addCriterion("from_mask <>", value, "fromMask");
            return (Criteria) this;
        }

        public Criteria andFromMaskGreaterThan(Integer value) {
            addCriterion("from_mask >", value, "fromMask");
            return (Criteria) this;
        }

        public Criteria andFromMaskGreaterThanOrEqualTo(Integer value) {
            addCriterion("from_mask >=", value, "fromMask");
            return (Criteria) this;
        }

        public Criteria andFromMaskLessThan(Integer value) {
            addCriterion("from_mask <", value, "fromMask");
            return (Criteria) this;
        }

        public Criteria andFromMaskLessThanOrEqualTo(Integer value) {
            addCriterion("from_mask <=", value, "fromMask");
            return (Criteria) this;
        }

        public Criteria andFromMaskIn(List<Integer> values) {
            addCriterion("from_mask in", values, "fromMask");
            return (Criteria) this;
        }

        public Criteria andFromMaskNotIn(List<Integer> values) {
            addCriterion("from_mask not in", values, "fromMask");
            return (Criteria) this;
        }

        public Criteria andFromMaskBetween(Integer value1, Integer value2) {
            addCriterion("from_mask between", value1, value2, "fromMask");
            return (Criteria) this;
        }

        public Criteria andFromMaskNotBetween(Integer value1, Integer value2) {
            addCriterion("from_mask not between", value1, value2, "fromMask");
            return (Criteria) this;
        }

        public Criteria andCidIsNull() {
            addCriterion("cid is null");
            return (Criteria) this;
        }

        public Criteria andCidIsNotNull() {
            addCriterion("cid is not null");
            return (Criteria) this;
        }

        public Criteria andCidEqualTo(Integer value) {
            addCriterion("cid =", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotEqualTo(Integer value) {
            addCriterion("cid <>", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThan(Integer value) {
            addCriterion("cid >", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThanOrEqualTo(Integer value) {
            addCriterion("cid >=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThan(Integer value) {
            addCriterion("cid <", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThanOrEqualTo(Integer value) {
            addCriterion("cid <=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidIn(List<Integer> values) {
            addCriterion("cid in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotIn(List<Integer> values) {
            addCriterion("cid not in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidBetween(Integer value1, Integer value2) {
            addCriterion("cid between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotBetween(Integer value1, Integer value2) {
            addCriterion("cid not between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andModifiedIsNull() {
            addCriterion("modified is null");
            return (Criteria) this;
        }

        public Criteria andModifiedIsNotNull() {
            addCriterion("modified is not null");
            return (Criteria) this;
        }

        public Criteria andModifiedEqualTo(Date value) {
            addCriterion("modified =", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedNotEqualTo(Date value) {
            addCriterion("modified <>", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedGreaterThan(Date value) {
            addCriterion("modified >", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedGreaterThanOrEqualTo(Date value) {
            addCriterion("modified >=", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedLessThan(Date value) {
            addCriterion("modified <", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedLessThanOrEqualTo(Date value) {
            addCriterion("modified <=", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedIn(List<Date> values) {
            addCriterion("modified in", values, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedNotIn(List<Date> values) {
            addCriterion("modified not in", values, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedBetween(Date value1, Date value2) {
            addCriterion("modified between", value1, value2, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedNotBetween(Date value1, Date value2) {
            addCriterion("modified not between", value1, value2, "modified");
            return (Criteria) this;
        }

        public Criteria andCreatedIsNull() {
            addCriterion("created is null");
            return (Criteria) this;
        }

        public Criteria andCreatedIsNotNull() {
            addCriterion("created is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedEqualTo(Date value) {
            addCriterion("created =", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedNotEqualTo(Date value) {
            addCriterion("created <>", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedGreaterThan(Date value) {
            addCriterion("created >", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedGreaterThanOrEqualTo(Date value) {
            addCriterion("created >=", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedLessThan(Date value) {
            addCriterion("created <", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedLessThanOrEqualTo(Date value) {
            addCriterion("created <=", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedIn(List<Date> values) {
            addCriterion("created in", values, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedNotIn(List<Date> values) {
            addCriterion("created not in", values, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedBetween(Date value1, Date value2) {
            addCriterion("created between", value1, value2, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedNotBetween(Date value1, Date value2) {
            addCriterion("created not between", value1, value2, "created");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNull() {
            addCriterion("tax_rate is null");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNotNull() {
            addCriterion("tax_rate is not null");
            return (Criteria) this;
        }

        public Criteria andTaxRateEqualTo(BigDecimal value) {
            addCriterion("tax_rate =", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotEqualTo(BigDecimal value) {
            addCriterion("tax_rate <>", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThan(BigDecimal value) {
            addCriterion("tax_rate >", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("tax_rate >=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThan(BigDecimal value) {
            addCriterion("tax_rate <", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("tax_rate <=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateIn(List<BigDecimal> values) {
            addCriterion("tax_rate in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotIn(List<BigDecimal> values) {
            addCriterion("tax_rate not in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax_rate between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax_rate not between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdIsNull() {
            addCriterion("base_unit_id is null");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdIsNotNull() {
            addCriterion("base_unit_id is not null");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdEqualTo(Integer value) {
            addCriterion("base_unit_id =", value, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdNotEqualTo(Integer value) {
            addCriterion("base_unit_id <>", value, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdGreaterThan(Integer value) {
            addCriterion("base_unit_id >", value, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("base_unit_id >=", value, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdLessThan(Integer value) {
            addCriterion("base_unit_id <", value, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdLessThanOrEqualTo(Integer value) {
            addCriterion("base_unit_id <=", value, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdIn(List<Integer> values) {
            addCriterion("base_unit_id in", values, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdNotIn(List<Integer> values) {
            addCriterion("base_unit_id not in", values, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdBetween(Integer value1, Integer value2) {
            addCriterion("base_unit_id between", value1, value2, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andBaseUnitIdNotBetween(Integer value1, Integer value2) {
            addCriterion("base_unit_id not between", value1, value2, "baseUnitId");
            return (Criteria) this;
        }

        public Criteria andUnitNameIsNull() {
            addCriterion("unit_name is null");
            return (Criteria) this;
        }

        public Criteria andUnitNameIsNotNull() {
            addCriterion("unit_name is not null");
            return (Criteria) this;
        }

        public Criteria andUnitNameEqualTo(String value) {
            addCriterion("unit_name =", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotEqualTo(String value) {
            addCriterion("unit_name <>", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameGreaterThan(String value) {
            addCriterion("unit_name >", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameGreaterThanOrEqualTo(String value) {
            addCriterion("unit_name >=", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameLessThan(String value) {
            addCriterion("unit_name <", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameLessThanOrEqualTo(String value) {
            addCriterion("unit_name <=", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameLike(String value) {
            addCriterion("unit_name like", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotLike(String value) {
            addCriterion("unit_name not like", value, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameIn(List<String> values) {
            addCriterion("unit_name in", values, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotIn(List<String> values) {
            addCriterion("unit_name not in", values, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameBetween(String value1, String value2) {
            addCriterion("unit_name between", value1, value2, "unitName");
            return (Criteria) this;
        }

        public Criteria andUnitNameNotBetween(String value1, String value2) {
            addCriterion("unit_name not between", value1, value2, "unitName");
            return (Criteria) this;
        }

        public Criteria andImgUrlIsNull() {
            addCriterion("img_url is null");
            return (Criteria) this;
        }

        public Criteria andImgUrlIsNotNull() {
            addCriterion("img_url is not null");
            return (Criteria) this;
        }

        public Criteria andImgUrlEqualTo(String value) {
            addCriterion("img_url =", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotEqualTo(String value) {
            addCriterion("img_url <>", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlGreaterThan(String value) {
            addCriterion("img_url >", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlGreaterThanOrEqualTo(String value) {
            addCriterion("img_url >=", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlLessThan(String value) {
            addCriterion("img_url <", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlLessThanOrEqualTo(String value) {
            addCriterion("img_url <=", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlLike(String value) {
            addCriterion("img_url like", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotLike(String value) {
            addCriterion("img_url not like", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlIn(List<String> values) {
            addCriterion("img_url in", values, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotIn(List<String> values) {
            addCriterion("img_url not in", values, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlBetween(String value1, String value2) {
            addCriterion("img_url between", value1, value2, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotBetween(String value1, String value2) {
            addCriterion("img_url not between", value1, value2, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andPayIdIsNull() {
            addCriterion("pay_id is null");
            return (Criteria) this;
        }

        public Criteria andPayIdIsNotNull() {
            addCriterion("pay_id is not null");
            return (Criteria) this;
        }

        public Criteria andPayIdEqualTo(String value) {
            addCriterion("pay_id =", value, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdNotEqualTo(String value) {
            addCriterion("pay_id <>", value, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdGreaterThan(String value) {
            addCriterion("pay_id >", value, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdGreaterThanOrEqualTo(String value) {
            addCriterion("pay_id >=", value, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdLessThan(String value) {
            addCriterion("pay_id <", value, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdLessThanOrEqualTo(String value) {
            addCriterion("pay_id <=", value, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdLike(String value) {
            addCriterion("pay_id like", value, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdNotLike(String value) {
            addCriterion("pay_id not like", value, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdIn(List<String> values) {
            addCriterion("pay_id in", values, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdNotIn(List<String> values) {
            addCriterion("pay_id not in", values, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdBetween(String value1, String value2) {
            addCriterion("pay_id between", value1, value2, "payId");
            return (Criteria) this;
        }

        public Criteria andPayIdNotBetween(String value1, String value2) {
            addCriterion("pay_id not between", value1, value2, "payId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}